Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
POSDepartmentID (FK)(PK) | A unique system-assigned identifier for the POSDepartment | ID_DPT_PS | Identity | integer | POSDepartment(ID_DPT_PS) |
LineItemVoidTotalAmount | The total monetary amount of line item voids by POS department for each REPORTING PERIOD. | CP_VD_LN_ITM_TOT | Money | decimal(16,5) | |
TotalLineItemVoidCount | The total number of line item voids by POS department for each REPORTING PERIOD. | QU_LTM_VD_TOT | QuantityTransactionCount | decimal(7,0) | |
PostTransactionVoidTotalAmount | The total monetary amount of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. | CP_VD_PST_TRN_TOT | Money | decimal(16,5) | |
TotalPostTransactionVoidCount | The total number of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
TransactionVoidTotalAmount | The total monetary amount of items cancelled by transaction void by POS department for each REPORTING PERIOD. | CP_VD_TRN_TOT | Money | decimal(16,5) | |
TotalTranactionVoidCount | The total number of items cancelled by transaction void by POS department for each REPORTING PERIOD. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
ReturnTotalAmount | The total monetary amount of returns by POS department for each REPORTING PERIOD. | CP_RTN_TOT | Money | decimal(16,5) | |
TotalReturnCount | The total number of returns by POS department for each REPORTING PERIOD. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |
RefundTotalAmount | The total monetary amount of refunds by POS department for each REPORTING PERIOD. | CP_RFD_TOT | Money | decimal(16,5) | |
TotalRefundCount | The total number of refunds by POS department for each REPORTING PERIOD. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |
EmployeeDiscountTotalAmount | The total monetary amount of employee discounts by POS department for each REPORTING PERIOD. | CP_DSC_EM_TOT | Money | decimal(16,5) | |
TotalEmployeeDiscountCount | The total number of employee discounted items by POS department for each REPORTING PERIOD. | QU_DSC_EM_TOT | QuantityTransactionCount | decimal(7,0) | |
MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts by POS department for each REPORTING PERIOD. | CP_DSC_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousDiscountCount | The total number of miscellaneous discounted items by POS department for each REPORTING PERIOD. | QU_DSC_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
StoreCouponTotalAmount | The total monetary amount of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. | CP_CPN_STR_TOT | Money | decimal(16,5) | |
TotalStoreCouponCount | he total number of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |
RedeemedContainerDepositTotalAmount | The total monetary amount of redeemed container deposits by POS department for each REPORTING PERIOD. | CP_DS_RDM_CNR_TOT | Money | decimal(16,5) | |
TotalRedeemedContainerDepositCount | he total number of redeemed container deposits by POS department for each REPORTING PERIOD. | QU_DS_RDM_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |
MarkdownTotalAmount | The total monetary amount of markdowns by POS department for each REPORTING PERIOD. | CP_MKD_TOT | Money | decimal(16,5) | |
TotalMarkdownCount | The total number of markdowns by POS department for each REPORTING PERIOD. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |
NetItemSalesTotalAmount | The total monetary amount of net item sales by POS department for each REPORTING PERIOD. | CP_SLS_NT_ITM_TOT | Money | decimal(16,5) | |
MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees by POS department for each REPORTING PERIOD. | CP_FE_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousFeeCount | The total number of miscellaneous fees by POS department for each REPORTING PERIOD. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
ContainerDepositTotalAmount | The total monetary amount of container deposits by POS department for each REPORTING PERIOD. | CP_DS_CNR_TOT | Money | decimal(16,5) | |
TotalContainerDepositCount | The total number of container deposits by POS department for each REPORTING PERIOD. | QU_DS_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |
TaxTotalAmount | The total monetary amount of tax item sales by POS department for each REPORTING PERIOD. | CP_TX_TOT | Money | decimal(16,5) | |
TaxExemptTotalAmount | The total monetary amount of tax exempt item sales by POS department for each REPORTING PERIOD. | CP_TX_EXM_TOT | Money | decimal(16,5) | |
TotalTaxExemptTransactionCount | The total number of tax exempt item sales by POS department for each REPORTING PERIOD. | QU_TRN_TX_EXM | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOverrideCount | The total number of line item overrides by POS department for each REPORTING PERIOD. | QU_LTM_OVRD_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalWeighedLineItemCount | The total number of weighed item sales by POS department for each REPORTING PERIOD. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedCount | The total number of keyed item sales by POS department for each REPORTING PERIOD. | QU_LTM_KY_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemScannedCount | The total number of scanned item sales by POS department for each REPORTING PERIOD. | QU_LTM_SC_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedPercentage | The number of items keyed as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_KY_TOT | Percent | decimal(7,4) | |
TotalLineItemScannedPercentage | The number of items scanned as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_SC_TOT | Percent | decimal(7,4) | |
TotalLineItemOpenDepartmentCount | The total number of items sold by a POS department for each REPORTING PERIOD. | QU_LTM_DPT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOpenDepartmentPercentage | The number of items sold through a department key as a percentage of total items sold by POS department for each REPORTING PERIOD. | PE_LTM_DPT_TOT | Percent | decimal(7,4) | |
TotalSaleLineItemCount | The total number of item sales by POS department for each REPORTING PERIOD. | QU_LTM_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |